DROP TABLE IF EXISTS `dcts_plugin_info`;
CREATE TABLE `dcts_plugin_info` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '类型',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '名称',
  `class_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '主类名称',
  `description` varchar(3000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '描述',
  `developer` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '开发者',
  `template` varchar(3000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '模板',
  `status` int NOT NULL COMMENT '状态 0未启动 1启动',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of dcts_plugin_info
-- ----------------------------
BEGIN;
INSERT INTO `dcts_plugin_info` VALUES (1, 'reader', 'mysqlreader', 'com.alibaba.datax.plugin.reader.mysqlreader.MysqlReader', 'useScene: prod. mechanism: Jdbc connection using the database, execute select sql, retrieve data from the ResultSet. warn: The more you know about the database, the less problems you encounter.', 'alibaba', '{\n    \"name\": \"mysqlreader\",\n    \"parameter\": {\n        \"username\": \"\",\n        \"password\": \"\",\n        \"column\": [],\n        \"connection\": [\n            {\n            \"jdbcUrl\": [],\n            \"table\": []\n            }\n        ],\n        \"where\": \"\"\n    }\n}', 1);
INSERT INTO `dcts_plugin_info` VALUES (2, 'reader', 'streamreader', 'com.alibaba.datax.plugin.reader.streamreader.StreamReader', 'useScene: prod. mechanism: Jdbc connection using the database, execute select sql, retrieve data from the ResultSet. warn: The more you know about the database, the less problems you encounter.', 'alibaba', '{\n    \"name\": \"mysqlreader\",\n    \"parameter\": {\n        \"username\": \"\",\n        \"password\": \"\",\n        \"column\": [],\n        \"connection\": [\n            {\n            \"jdbcUrl\": [],\n            \"table\": []\n            }\n        ],\n        \"where\": \"\"\n    }\n}', 1);
INSERT INTO `dcts_plugin_info` VALUES (3, 'writer', 'streamwriter', 'com.alibaba.datax.plugin.writer.streamwriter.StreamWriter', 'useScene: prod. mechanism: Jdbc connection using the database, execute select sql, retrieve data from the ResultSet. warn: The more you know about the database, the less problems you encounter.', 'alibaba', '{\n    \"name\": \"mysqlreader\",\n    \"parameter\": {\n        \"username\": \"\",\n        \"password\": \"\",\n        \"column\": [],\n        \"connection\": [\n            {\n            \"jdbcUrl\": [],\n            \"table\": []\n            }\n        ],\n        \"where\": \"\"\n    }\n}', 1);
INSERT INTO `dcts_plugin_info` VALUES (4, 'writer', 'mysqlwriter', 'com.alibaba.datax.plugin.writer.mysqlwriter.MysqlWriter', 'useScene: prod. mechanism: Jdbc connection using the database, execute select sql, retrieve data from the ResultSet. warn: The more you know about the database, the less problems you encounter.', 'alibaba', '{\n    \"name\": \"mysqlreader\",\n    \"parameter\": {\n        \"username\": \"\",\n        \"password\": \"\",\n        \"column\": [],\n        \"connection\": [\n            {\n            \"jdbcUrl\": [],\n            \"table\": []\n            }\n        ],\n        \"where\": \"\"\n    }\n}', 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
